home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 507 < prev    next >
Unknown  |  1998-01-30  |  575 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 52 45 53 |CHILD IN|SERT RES|
|00000010| 54 52 49 43 54 00 20 20 | 20 20 2f 2a 20 45 52 77 |TRICT.  |  /* ERw|
|00000020| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00000030| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 20 20 2f 2a 20 |time */.|.    /* |
|00000040| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|00000050| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 43 48 |ase %Chi|ld ON CH|
|00000060| 49 4c 44 20 49 4e 53 45 | 52 54 20 52 45 53 54 52 |ILD INSE|RT RESTR|
|00000070| 49 43 54 20 2a 2f 0d 0a | 20 20 20 20 73 65 6c 65 |ICT */..|    sele|
|00000080| 63 74 20 63 6f 75 6e 74 | 28 2a 29 20 69 6e 74 6f |ct count|(*) into|
|00000090| 20 6e 75 6d 72 6f 77 73 | 0d 0a 20 20 20 20 20 20 | numrows|..      |
|000000a0| 66 72 6f 6d 20 25 50 61 | 72 65 6e 74 0d 0a 20 20 |from %Pa|rent..  |
|000000b0| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 |    wher|e..     |
|000000c0| 20 20 20 2f 2a 20 25 25 | 4a 6f 69 6e 46 4b 50 4b |   /* %%|JoinFKPK|
|000000d0| 28 3a 25 25 4e 65 77 2c | 25 50 61 72 65 6e 74 2c |(:%%New,|%Parent,|
|000000e0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|000000f0| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |..      |  %JoinF|
|00000100| 4b 50 4b 28 3a 25 4e 65 | 77 2c 25 50 61 72 65 6e |KPK(:%Ne|w,%Paren|
|00000110| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 3b |t," = ",|" and");|
|00000120| 0d 0a 20 20 20 20 69 66 | 20 28 0d 0a 20 20 20 20 |..    if| (..    |
|00000130| 20 20 2f 2a 20 25 25 4e | 6f 74 6e 75 6c 6c 46 4b |  /* %%N|otnullFK|
|00000140| 28 3a 25 25 4e 65 77 2c | 22 20 69 73 20 6e 6f 74 |(:%%New,|" is not|
|00000150| 20 6e 75 6c 6c 20 61 6e | 64 22 29 20 2a 2f 0d 0a | null an|d") */..|
|00000160| 20 20 20 20 20 20 25 4e | 6f 74 6e 75 6c 6c 46 4b |      %N|otnullFK|
|00000170| 28 3a 25 4e 65 77 2c 22 | 20 69 73 20 6e 6f 74 20 |(:%New,"| is not |
|00000180| 6e 75 6c 6c 20 61 6e 64 | 22 29 0d 0a 20 20 20 20 |null and|")..    |
|00000190| 20 20 6e 75 6d 72 6f 77 | 73 20 3d 20 30 0d 0a 20 |  numrow|s = 0.. |
|000001a0| 20 20 20 29 0d 0a 20 20 | 20 20 74 68 65 6e 0d 0a |   )..  |  then..|
|000001b0| 20 20 20 20 20 20 72 61 | 69 73 65 5f 61 70 70 6c |      ra|ise_appl|
|000001c0| 69 63 61 74 69 6f 6e 5f | 65 72 72 6f 72 28 0d 0a |ication_|error(..|
|000001d0| 20 20 20 20 20 20 20 20 | 2d 32 30 30 30 32 2c 0d |        |-20002,.|
|000001e0| 0a 20 20 20 20 20 20 20 | 20 27 43 61 6e 6e 6f 74 |.       | 'Cannot|
|000001f0| 20 49 4e 53 45 52 54 20 | 22 25 43 68 69 6c 64 22 | INSERT |"%Child"|
|00000200| 20 62 65 63 61 75 73 65 | 20 22 25 50 61 72 65 6e | because| "%Paren|
|00000210| 74 22 20 64 6f 65 73 20 | 6e 6f 74 20 65 78 69 73 |t" does |not exis|
|00000220| 74 2e 27 0d 0a 20 20 20 | 20 20 20 29 3b 0d 0a 20 |t.'..   |   );.. |
|00000230| 20 20 20 65 6e 64 20 69 | 66 3b 0d 0a 00 18 27    |   end i|f;....' |
+--------+-------------------------+-------------------------+--------+--------+